Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.333 lượt xem;
- MasterPage.master.cs
- project /
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using System.Data.OleDb;
12
13 public partial class MasterPage : System.Web.UI.MasterPage
14 {
15 TimKiemData tk;
16
17 protected void Page_Load(object sender, EventArgs e)
18 {
19 lblslkhach.Text = Application.Contents["sltruycap"].ToString();
20 lbltructuyen.Text = Application.Contents["sltructuyen"].ToString();
21 if (Page.IsPostBack==false)
22 {
23
24
25 ado.ketNoi();
26 OleDbDataAdapter da = new OleDbDataAdapter("Select * From tblhang",ado.con);
27 DataTable dt = new DataTable();
28 da.Fill(dt);
29 MenuItem tmp;
30
31 foreach (DataRow dr in dt.Rows)
32
33 {
34
35 tmp = new MenuItem(dr[1].ToString(), dr[0].ToString(), "~/Images/blue_arrow.gif");
36 tmp.NavigateUrl = "sanpham.aspx?mahang=" +dr[0].ToString();
37 tmp.SeparatorImageUrl = "~/Images/nganmenu.gif";
38 Menu1.Items.Add(tmp);
39
40
41
42 }
43 OleDbDataAdapter da1 = new OleDbDataAdapter("Select * From timkiem", ado.con);
44 DataTable dt1 = new DataTable();
45 da1.Fill(dt1); MenuItem tmp1;
46 foreach (DataRow dr1 in dt1.Rows)
47 {
48 tmp1 = new MenuItem(dr1[2].ToString(), dr1[0].ToString(), "~/Images/blue_arrow.gif");
49 tmp1.NavigateUrl = "timkiem.aspx?gia=" + dr1[0].ToString()+"&gia2=" + dr1[1].ToString();
50 tmp1.SeparatorImageUrl = "~/Images/nganmenu.gif";
51 Menu5.Items.Add(tmp1);
52
53 }
54 OleDbDataAdapter da2 = new OleDbDataAdapter("Select * From phongcach", ado.con);
55 DataTable dt2 = new DataTable();
56 da2.Fill(dt2); MenuItem tmp2;
57 foreach (DataRow dr2 in dt2.Rows)
58 {
59 tmp2 = new MenuItem(dr2[1].ToString(), dr2[0].ToString(), "~/Images/blue_arrow.gif");
60 tmp2.NavigateUrl = "phongcach.aspx?id=" + dr2[0].ToString();
61 tmp2.SeparatorImageUrl = "~/Images/nganmenu.gif";
62 Menu6.Items.Add(tmp2);
63
64 }
65 OleDbDataAdapter da3 = new OleDbDataAdapter("Select * From kieudang", ado.con);
66 DataTable dt3 = new DataTable();
67 da3.Fill(dt3); MenuItem tmp3;
68 foreach (DataRow dr3 in dt3.Rows)
69 {
70 tmp3 = new MenuItem(dr3[1].ToString(), dr3[0].ToString(), "~/Images/blue_arrow.gif");
71 tmp3.NavigateUrl = "kieudang.aspx?id=" + dr3[0].ToString();
72 tmp3.SeparatorImageUrl = "~/Images/nganmenu.gif";
73 Menu7.Items.Add(tmp3);
74
75 }
76
77 }
78 }
79
80
81 protected void btndangnhap_Click(object sender, EventArgs e)
82 {
83
84
85
86 ado.ketNoi();
87 string query = "select * from tbluser where email='" + txtemail.Text + "' and matkhau='" + txtpass.Text + "'";
88 ado.rd = ado.getData(query);
89 if (ado.rd.Read())
90 {
91 FormsAuthentication.SetAuthCookie(txtemail.Text, true);
92 Session["email"] = txtemail.Text;
93 Session["matkhau"] = ado.rd[1].ToString();
94 Session["quyen"] = ado.rd[2].ToString();
95 Session["hoten"] = ado.rd[3].ToString();
96 Session["diachi"] = ado.rd[4].ToString();
97 Session["dienthoai"] = ado.rd[5].ToString();
98 Session["soCMND"] = ado.rd[6].ToString();
99 Session["mataikhoan"] = ado.rd[7].ToString();
100
101 if (Session["quyen"].ToString() == "admin")
102 Response.Redirect("themqtri.aspx");
103 else
104 Response.Redirect("thongtintaikhoan.aspx", true);
105 }
106 else
107 {
108 txtemail.Focus();
109 }
110
111 ado.rd.Dispose();
112 ado.dongKetNoi();
113 }
114
115 protected void timKiem(object sender, CommandEventArgs e)
116 {
117 {
118 try
119 {
120 Session["TuKhoa"] = TextBox3.Text;
121 Session["KQTimKiem"] = null;
122 tk = new TimKiemData();
123 DataTable tb;
124 tb = tk.setTable();
125 //string TinhTrang = "";
126 ado.ketNoi();
127 string query = "";
128 if (TextBox3.Text != "")
129 {
130 query = "Select Anh, TenSP,Gia,soluong,'chitiet.aspx?tensp='+tensp as chitiet from tblSanPham where TenSP like '" + TextBox3.Text + "%'";
131 }
132 ado.rd = ado.getData(query);
133 while (ado.rd.Read())
134 {
135 tb = tk.dienVaoBang(tb, ado.rd["Anh"].ToString(), ado.rd["TenSP"].ToString(), Convert.ToDouble(ado.rd["Gia"]), Convert.ToDouble(ado.rd["soluong"]), ado.rd["chitiet"].ToString());
136
137 }
138 ado.dongKetNoi();
139 Session["KQTimKiem"] = tb;
140 Response.Redirect("timten.aspx", true);
141 }
142 catch (Exception ex)
143 {
144
145 }
146 }
147 }
148
149 }
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using System.Data.OleDb;
12
13 public partial class MasterPage : System.Web.UI.MasterPage
14 {
15 TimKiemData tk;
16
17 protected void Page_Load(object sender, EventArgs e)
18 {
19 lblslkhach.Text = Application.Contents["sltruycap"].ToString();
20 lbltructuyen.Text = Application.Contents["sltructuyen"].ToString();
21 if (Page.IsPostBack==false)
22 {
23
24
25 ado.ketNoi();
26 OleDbDataAdapter da = new OleDbDataAdapter("Select * From tblhang",ado.con);
27 DataTable dt = new DataTable();
28 da.Fill(dt);
29 MenuItem tmp;
30
31 foreach (DataRow dr in dt.Rows)
32
33 {
34
35 tmp = new MenuItem(dr[1].ToString(), dr[0].ToString(), "~/Images/blue_arrow.gif");
36 tmp.NavigateUrl = "sanpham.aspx?mahang=" +dr[0].ToString();
37 tmp.SeparatorImageUrl = "~/Images/nganmenu.gif";
38 Menu1.Items.Add(tmp);
39
40
41
42 }
43 OleDbDataAdapter da1 = new OleDbDataAdapter("Select * From timkiem", ado.con);
44 DataTable dt1 = new DataTable();
45 da1.Fill(dt1); MenuItem tmp1;
46 foreach (DataRow dr1 in dt1.Rows)
47 {
48 tmp1 = new MenuItem(dr1[2].ToString(), dr1[0].ToString(), "~/Images/blue_arrow.gif");
49 tmp1.NavigateUrl = "timkiem.aspx?gia=" + dr1[0].ToString()+"&gia2=" + dr1[1].ToString();
50 tmp1.SeparatorImageUrl = "~/Images/nganmenu.gif";
51 Menu5.Items.Add(tmp1);
52
53 }
54 OleDbDataAdapter da2 = new OleDbDataAdapter("Select * From phongcach", ado.con);
55 DataTable dt2 = new DataTable();
56 da2.Fill(dt2); MenuItem tmp2;
57 foreach (DataRow dr2 in dt2.Rows)
58 {
59 tmp2 = new MenuItem(dr2[1].ToString(), dr2[0].ToString(), "~/Images/blue_arrow.gif");
60 tmp2.NavigateUrl = "phongcach.aspx?id=" + dr2[0].ToString();
61 tmp2.SeparatorImageUrl = "~/Images/nganmenu.gif";
62 Menu6.Items.Add(tmp2);
63
64 }
65 OleDbDataAdapter da3 = new OleDbDataAdapter("Select * From kieudang", ado.con);
66 DataTable dt3 = new DataTable();
67 da3.Fill(dt3); MenuItem tmp3;
68 foreach (DataRow dr3 in dt3.Rows)
69 {
70 tmp3 = new MenuItem(dr3[1].ToString(), dr3[0].ToString(), "~/Images/blue_arrow.gif");
71 tmp3.NavigateUrl = "kieudang.aspx?id=" + dr3[0].ToString();
72 tmp3.SeparatorImageUrl = "~/Images/nganmenu.gif";
73 Menu7.Items.Add(tmp3);
74
75 }
76
77 }
78 }
79
80
81 protected void btndangnhap_Click(object sender, EventArgs e)
82 {
83
84
85
86 ado.ketNoi();
87 string query = "select * from tbluser where email='" + txtemail.Text + "' and matkhau='" + txtpass.Text + "'";
88 ado.rd = ado.getData(query);
89 if (ado.rd.Read())
90 {
91 FormsAuthentication.SetAuthCookie(txtemail.Text, true);
92 Session["email"] = txtemail.Text;
93 Session["matkhau"] = ado.rd[1].ToString();
94 Session["quyen"] = ado.rd[2].ToString();
95 Session["hoten"] = ado.rd[3].ToString();
96 Session["diachi"] = ado.rd[4].ToString();
97 Session["dienthoai"] = ado.rd[5].ToString();
98 Session["soCMND"] = ado.rd[6].ToString();
99 Session["mataikhoan"] = ado.rd[7].ToString();
100
101 if (Session["quyen"].ToString() == "admin")
102 Response.Redirect("themqtri.aspx");
103 else
104 Response.Redirect("thongtintaikhoan.aspx", true);
105 }
106 else
107 {
108 txtemail.Focus();
109 }
110
111 ado.rd.Dispose();
112 ado.dongKetNoi();
113 }
114
115 protected void timKiem(object sender, CommandEventArgs e)
116 {
117 {
118 try
119 {
120 Session["TuKhoa"] = TextBox3.Text;
121 Session["KQTimKiem"] = null;
122 tk = new TimKiemData();
123 DataTable tb;
124 tb = tk.setTable();
125 //string TinhTrang = "";
126 ado.ketNoi();
127 string query = "";
128 if (TextBox3.Text != "")
129 {
130 query = "Select Anh, TenSP,Gia,soluong,'chitiet.aspx?tensp='+tensp as chitiet from tblSanPham where TenSP like '" + TextBox3.Text + "%'";
131 }
132 ado.rd = ado.getData(query);
133 while (ado.rd.Read())
134 {
135 tb = tk.dienVaoBang(tb, ado.rd["Anh"].ToString(), ado.rd["TenSP"].ToString(), Convert.ToDouble(ado.rd["Gia"]), Convert.ToDouble(ado.rd["soluong"]), ado.rd["chitiet"].ToString());
136
137 }
138 ado.dongKetNoi();
139 Session["KQTimKiem"] = tb;
140 Response.Redirect("timten.aspx", true);
141 }
142 catch (Exception ex)
143 {
144
145 }
146 }
147 }
148
149 }